{{frmt=html}}{{lims=divn}}{{name=Computers}}{{lang=en}}{{cols=name=Name%3Bcver=Client Version%3Bdivn=Division}}{{cach=hold:300}}
{{qstr=sql;select computerName,computerID,computerClientVersion,computerPlatform,divisionName
from
{oj KSComputers LEFT OUTER JOIN KSComputerDivisions ON computerDivisionID=divisionID}
where
{{iftg=ptyp:divn;computerDivisionID={{item=pdai}}
AND }}computerAllowed>0
order by
{{iftg=sort:cver;computerClientVersion,
}}{{iftg=sort:divn;divisionName,
}}computerName}}